﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Admin/AdminMsaster.master" AutoEventWireup="true" CodeFile="LookBorrowedHistory.aspx.cs" Inherits="Admin_LookBorrowedHistory" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
    <link href="assets/css/bootstrap-datetimepicker.min.css" rel="stylesheet" />
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BooksManagerSystemConnectionString %>">
        <SelectParameters>
            <asp:Parameter Name="name" />
            <asp:Parameter Name="date1" />
            <asp:Parameter Name="date2" />
        </SelectParameters>
    </asp:SqlDataSource>

    <div id="page-wrapper">
        <div id="page-inner">
            <div class="row">
                <div class="col-md-12">
                    <h1 class="page-header">借阅历史查询 <small>您可以在选择时间段查询借出并已归还的图书记录</small>
                    </h1>
                </div>
            </div>
            <div class="row">

                <div class="col-md-12">
                    <!-- Advanced Tables -->
                    <div class="panel panel-default">
                        <div class="panel-heading">
                            <p style="font-size: 25px;">选择时间段查看借出并已归还记录查询</p>
                        </div>

                        <div class="container" style="width: 970px">

                            <fieldset>
                                <legend></legend>
                                <div class="control-group" style="float: left; margin-left: 10px; margin-right: auto;">

                                    <div class="controls  input-append date form_date" data-date="" data-date-format="dd MM yyyy" data-link-field="dtp_input2" data-link-format="yyyy-mm-dd">

                                        <label class="control-label">起始时间</label>
                                        <input runat="Server" id="date1" class="form-control" style="width: 200px;" size="16" type="text" value="" readonly>
                                        <span class="add-on"><i class="icon-remove"></i></span>
                                        <span class="add-on"><i class="icon-th"></i></span>
                                    </div>
                                    <input type="hidden" id="dtp_input2" value="" /><br />
                                </div>

                                <div class="control-group" style="float: left; margin-left: 50px; margin-right: auto;">

                                    <div class="controls  input-append date form_date" data-date="" data-date-format="dd MM yyyy" data-link-field="dtp_input2" data-link-format="yyyy-mm-dd">
                                        <label class="control-label">截至时间</label>
                                        <input runat="Server" id="date2" class="form-control" style="width: 200px;" size="16" type="text" value="" readonly>

                                        <span class="add-on"><i class="icon-remove"></i></span>
                                        <span class="add-on"><i class="icon-th"></i></span>
                                    </div>
                                    <input type="hidden" id="Hidden1" value="" /><br />

                                </div>
                                
                                
                                 <asp:TextBox ID="TextBox1" CssClass="form-control" runat="server" Style="width: 123px; margin-left: 470px;margin-top:25px; position: absolute; " placeholder="筛选条件..."  />
                                <asp:Button ID="Button3" CssClass="btn btn-primary" runat="server" Text="查询全部" Style="margin-top: -98px; margin-left: 597px;" OnClick="Cancel_Click" />
                                 <asp:Button ID="Button2" CssClass="btn btn-primary" runat="server" Text="查询图书" Style="margin-top: -98px; " OnClick="book_Click" />
                                 <asp:Button ID="Cancel" CssClass="btn btn-primary" runat="server" Text="查询读者" Style="margin-top: -98px; " OnClick="reader_Click" />
                            <asp:Button ID="Button1" CssClass="btn  btn-success" runat="server" Text="导出报表" Style="margin-top: -98px; " OnClick="baobiao_Click" />

                            </fieldset>
                            
                           
                  
                        </div>
                        <div class="panel-body">
                            <div class="table-responsive">
                                <!-- 数据源开始 -->

                                <asp:GridView ID="mybookdata" class="mytablestyle table table-striped table-bordered table-hover" runat="server" DataSourceID="SqlDataSource1">

                                    <Columns>
                                        <asp:TemplateField HeaderText="选择">
                                            <ItemStyle HorizontalAlign="Center" />
                                            <ItemTemplate>
                                                <asp:CheckBox ID="CheckBox" CssClass="checkbox" runat="server"></asp:CheckBox>
                                            </ItemTemplate>
                                        </asp:TemplateField>
                                    </Columns>
                                </asp:GridView>
                                <!-- 数据源结束 -->
                                <br />

                                <script> window.onload = function asdasd() {
     $("#ContentPlaceHolder1_mybookdata tr:first").wrap("<thead></thead>");
     $("#ContentPlaceHolder1_mybookdata thead").insertBefore("#GriView1 tbody");
     $("#ContentPlaceHolder1_mybookdata").dataTable();
 }</script>
                            </div>

                        </div>
                    </div>

                    <!--End Advanced Tables -->
                </div>

            </div>
            <!-- /. ROW  -->



        </div>

        <!-- /. PAGE INNER  -->
    </div>
    <script>
        function loadtable() {
            $("#ContentPlaceHolder1_mybookdata tr:first").wrap("<thead></thead>");
            $("#ContentPlaceHolder1_mybookdata thead").insertBefore("#GriView1 tbody");
            $("#ContentPlaceHolder1_mybookdata").dataTable();
        };
    </script>


    <!-- Bootstrap Js必要 -->
    <script src="assets/js/jquery-1.10.2.js"></script>
    <script src="assets/js/bootstrap.min.js"></script>



    <script src="assets/js/bootstrap-datetimepicker.min.js"></script>
    <script src="assets/js/bootstrap-datetimepicker.zh-CN.js"></script>
    <!-- Metis Menu Js -->
    <script src="assets/js/jquery.metisMenu.js"></script>
    <!-- DATA TABLE SCRIPTS -->
    <script src="assets/js/ReportTables.js"></script>
    <script src="assets/js/dataTables/dataTables.bootstrap.js"></script>
    <!-- Custom Js -->
    <script src="assets/js/custom-scripts.js"></script>
    <!-- 日期管理 -->
    <script type="text/javascript">
        $('.form_date').datetimepicker({
            language: 'zh-CN',
            weekStart: 1,
            todayBtn: 1,
            autoclose: 1,
            todayHighlight: 1,
            startView: 2,
            minView: 2,
            forceParse: 0,
            format: 'yyyy-mm-dd'
        });
    </script>

</asp:Content>

